# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月16日
"""
import openpyxl

myBook=openpyxl.load_workbook('收入表.xlsx')
mySheet=myBook.active
mySheet['E5']=sum([myCell.value for myCell in mySheet[5][1:4]])
mySheet['E6']=sum([myCell.value for myCell in mySheet[6][1:4]])
mySheet['E7']=sum([myCell.value for myCell in mySheet[7][1:4]])
mySheet['E8']=sum([myCell.value for myCell in mySheet[8][1:4]])

myBook.save('收入表.xlsx')
